/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50728 (5.7.28)
 Source Host           : localhost:3306
 Source Schema         : applet

 Target Server Type    : MySQL
 Target Server Version : 50728 (5.7.28)
 File Encoding         : 65001

 Date: 21/02/2024 17:54:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for appletuser
-- ----------------------------
DROP TABLE IF EXISTS `appletuser`;
CREATE TABLE `appletuser` (
  `id` varchar(255) NOT NULL,
  `avatarUrl` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `nickName` varchar(255) DEFAULT NULL,
  `openId` varbinary(255) DEFAULT NULL,
  `province` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户信息表';

-- ----------------------------
-- Records of appletuser
-- ----------------------------
BEGIN;
INSERT INTO `appletuser` (`id`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `openId`, `province`) VALUES ('1750382908197081089', 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', '', '', 0, '', '微信用户', 0x6F665554713065366C376C365F386C5868326B34563039474D594141, '');
INSERT INTO `appletuser` (`id`, `avatarUrl`, `city`, `country`, `gender`, `language`, `nickName`, `openId`, `province`) VALUES ('1752596721130553346', 'https://thirdwx.qlogo.cn/mmopen/vi_32/POgEwh4mIHO4nibH0KlMECNjjGxQUq24ZEaGT4poC6icRiccVGKSyXwibcPq4BWmiaIGuG1icwxaQX6grC9VemZoJ8rg/132', '', '', 0, '', '微信用户', 0x6F792D6264354D6D4C46443975707A455A4F734F4674593471737349, '');
COMMIT;

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `id` varchar(255) NOT NULL,
  `pic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of banner
-- ----------------------------
BEGIN;
INSERT INTO `banner` (`id`, `pic`) VALUES ('1', '2024/01/30/628657406bb541e2896b6a751bd53970.png');
INSERT INTO `banner` (`id`, `pic`) VALUES ('2', '2024/01/30/f350e751f66945dfb24c7b9b061e59b9.png');
INSERT INTO `banner` (`id`, `pic`) VALUES ('3', '2024/01/30/de1ff8301bf64ccc94b88471f5d3669e.png');
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '菜单名称',
  `name` varchar(255) DEFAULT NULL COMMENT '菜单name',
  `fid` int(11) DEFAULT '0' COMMENT '是否二级菜单，父级菜单ID',
  `button` varchar(255) DEFAULT NULL,
  `menuOrder` int(11) DEFAULT '0',
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (1, '系统管理', 'permissions', 0, NULL, 1, 'el-icon-s-help');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (2, '角色管理', 'role', 1, NULL, 0, 'form');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (3, '用户管理', 'user', 1, NULL, 0, 'form');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (4, '菜单管理', 'menu', 1, NULL, 0, 'form');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (5, '新闻', 'news', 0, NULL, 0, 'el-icon-s-help');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (6, '新闻组件', 'newsindex', 5, NULL, 1, 'form');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (7, '产品', 'product', 0, NULL, 0, 'el-icon-s-help');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (9, '产品管理', 'productindex', 7, NULL, 0, 'form');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (8, '产品分类', 'productclass', 7, NULL, 0, 'form');
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (15, '大师傅爱的方式阿斯蒂芬', 'adsfasdfdsaf', 0, NULL, 1, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (16, '22323', '2323123', 15, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (17, '123123', '123123123', 15, NULL, 1, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (18, '菜单名称1', 'name1', 0, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (24, '12', '23123', 18, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (22, '111', '222', 1, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (25, '23', '123', 18, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (27, 'q1q', '1w1w', 0, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (28, '12w12w', 'wdswde', 0, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (29, 'few', 'qwf', 27, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (30, 'fwe', 'dw', 28, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (31, 'fwe', 'wdewed', 27, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (32, 'wefqwe', 'fewqfqwefwef', 28, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (33, 'ewf', 'wefwef', 28, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (34, 'ewf', 'wefwef', 28, NULL, 0, NULL);
INSERT INTO `menu` (`id`, `title`, `name`, `fid`, `button`, `menuOrder`, `icon`) VALUES (35, 'ewf', 'wefwef', 28, NULL, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for menubutton
-- ----------------------------
DROP TABLE IF EXISTS `menubutton`;
CREATE TABLE `menubutton` (
  `id` bigint(20) NOT NULL,
  `menuId` int(11) DEFAULT NULL,
  `createTime` date DEFAULT NULL,
  `updateTime` date DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '按钮名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menubutton
-- ----------------------------
BEGIN;
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219769646, 2, '2023-04-22', '2023-04-22', 'delete', '删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219776528, 2, '2023-04-22', '2023-04-22', 'edit', '编辑');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219781571, 2, '2023-04-22', '2023-04-22', 'add', '新增');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219779741, 3, '2023-04-22', '2023-04-22', 'edit', '编辑');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219783621, 3, '2023-04-22', '2023-04-22', 'delete', '删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219783159, 3, '2023-04-22', '2023-04-22', 'batchDelete', '批量删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219783797, 3, '2023-04-22', '2023-04-22', 'add', '新增');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219789186, 4, '2023-04-22', '2023-04-22', 'batchSync', '批量同步');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219792508, 4, '2023-04-22', '2023-04-22', 'batchDelete', '批量删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219792708, 4, '2023-04-22', '2023-04-22', 'addButton', '新增按钮');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219794383, 4, '2023-04-22', '2023-04-22', 'addMenu', '新增菜单');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219793454, 4, '2023-04-22', '2023-04-22', 'delete', '删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219795789, 4, '2023-04-22', '2023-04-22', 'edit', '编辑');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219802696, 6, '2023-04-22', '2023-04-22', 'batchDeletion', '批量删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219802435, 6, '2023-04-22', '2023-04-22', 'delete', '删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219803060, 6, '2023-04-22', '2023-04-22', 'edit', '编辑');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219803827, 6, '2023-04-22', '2023-04-22', 'export', '导出');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219803880, 6, '2023-04-22', '2023-04-22', 'import', '导入');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219805982, 6, '2023-04-22', '2023-04-22', 'add', '添加');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219809356, 8, '2023-04-22', '2023-04-22', 'delete', '删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219807724, 8, '2023-04-22', '2023-04-22', 'edit', '编辑');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219811333, 8, '2023-04-22', '2023-04-22', 'add', '添加');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219813403, 9, '2023-04-22', '2023-04-22', 'delete', '删除');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219815955, 9, '2023-04-22', '2023-04-22', 'edit', '编辑');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5333429219818378, 9, '2023-04-22', '2023-04-22', 'add', '添加');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5428276022798968, 29, '2024-01-15', '2024-01-15', 'anniu1', '按钮1');
INSERT INTO `menubutton` (`id`, `menuId`, `createTime`, `updateTime`, `type`, `name`) VALUES (5428348227866822, 35, '2024-01-15', '2024-01-15', 'adsfasdfdsf', 'dfsgdfgs');
COMMIT;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL COMMENT '标题',
  `fTitle` varchar(400) DEFAULT NULL COMMENT '副标题',
  `pic` varchar(255) DEFAULT NULL COMMENT '图片',
  `s_pic` varchar(70) DEFAULT NULL COMMENT '缩略图',
  `contents` text COMMENT '内容',
  `update` date DEFAULT NULL COMMENT '时间',
  `num` int(11) NOT NULL DEFAULT '0' COMMENT '点击数',
  `top` int(11) NOT NULL DEFAULT '0' COMMENT '推荐值',
  `author` varchar(30) DEFAULT NULL COMMENT '作者',
  `webtitle` varchar(80) DEFAULT NULL COMMENT '网页标题',
  `webkey` varchar(160) DEFAULT NULL COMMENT '网页关键词',
  `webdes` varchar(200) DEFAULT NULL COMMENT '网页描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=150 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of news
-- ----------------------------
BEGIN;
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (1, '第一个新闻', '副标题', '/public/uploads/20230423/c04fb45a37aef2f8fdfdd23ae17ba4cd.png', NULL, '<p>qwqwwqwqw</p>', '2023-04-23', 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (4, '123123', '123123123', '', NULL, '', '2023-10-16', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (5, 'adscsadc', '123123123', '', NULL, '', '2023-10-16', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (6, '第一个新闻', '副标题', '/public/uploads/20230423/c04fb45a37aef2f8fdfdd23ae17ba4cd.png', NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (7, '123123', '123123123', NULL, NULL, NULL, NULL, 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (8, 'adscsadc', '123123123', NULL, NULL, NULL, NULL, 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (9, '123123123123', '123123123123', '', NULL, '<pre><code >\n\n\n\nadsfadsfdsafadsfds        afdsafadsf阿第三方阿斯蒂芬阿斯蒂芬阿第三方adsfadsf \n</code></pre><table style=\"width: auto;\"><tbody><tr><th colSpan=\"1\" rowSpan=\"1\" width=\"auto\">234234</th><th colSpan=\"1\" rowSpan=\"1\" width=\"auto\">324234</th></tr><tr><td colSpan=\"1\" rowSpan=\"1\" width=\"auto\">234234</td><td colSpan=\"1\" rowSpan=\"1\" width=\"auto\">234234234234</td></tr></tbody></table><p><br></p><pre><code >123123123</code></pre><pre><code >123123123123</code></pre><pre><code >111111111123123123123</code></pre><p><br></p><p><img src=\"/public/editor/202310/65f9ded0-35ec-4cca-aa42-b3d53e8ea304.jpg\" alt=\"\" data-href=\"\" style=\"\"/></p><ol><li></li></ol><h2>爱的方式</h2><hr/><h2>爱的方式</h2><h2>asddsfdsfadsfadsf</h2><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>', '2023-10-16', 3, 2, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (11, 'adsfsadf', 'cadscasd', '', NULL, '<p>asdcasdc</p>', '2024-01-16', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (12, 'adsfsadf', 'cadscasd', '', NULL, '<p>asdcasdc</p>', '2024-01-16', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (13, 'adsfsadf', 'cadscasd', '', NULL, '<p>asdcasdc</p>', '2024-01-16', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (14, 'adsfsadf', 'cadscasd', '', NULL, '<p>asdcasdc</p>', '2024-01-16', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (15, 'adsfsadf', 'cadscasd', '', NULL, '<p>asdcasdc</p>', '2024-01-16', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (16, 'adsfsadf', 'cadscasd', '', NULL, '<p>asdcasdc</p>', '2024-01-16', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (20, '热鹅鹅鹅饿单方事故', '电风扇广东十分广东佛山', '/public/20241/05cea1d5-5a17-4552-b9b9-4c36f116050a.jpg', NULL, '', '2024-01-20', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (21, 'ghdfhdfghdfgh', 'dfghdfghdfgh', '/public/20241/609cc426-482f-41ba-bbb6-6ad2cacc4267.jpg', NULL, '', '2024-01-20', 1, 1, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (22, '行宫\n(元稹)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (23, '行宫\n(元稹)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (24, '登鹳雀楼\n(王之涣)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (25, '新嫁娘词\n(王建)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (26, '相思\n(王维)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (27, '杂诗\n(王维)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (28, '鹿柴\n(王维)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (29, '竹里馆\n(王维)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (30, '山中送别\n(王维)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (31, '问刘十九\n(白居易)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (32, '哥舒歌\n(西鄙人)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (33, '静夜思\n(李白)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (34, '怨情\n(李白)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (35, '登乐游原\n(李商隐)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (36, '听筝\n(李端)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (37, '渡汉江\n(宋之问)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (38, '八阵图\n(杜甫)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (39, '宿建德江\n(孟浩然)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (40, '春晓\n(孟浩然)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (41, '春怨\n(金昌绪)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (42, '江雪\n(柳宗元)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (43, '秋夜寄邱员外\n(韦应物)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (44, '终南望余雪\n(祖咏)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (45, '宫词\n(张祜)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (46, '寻隐者不遇\n(贾岛)', NULL, NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (47, '送崔九\n(裴迪)', 'werwer', NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (48, '送灵澈上人\n(刘长卿)', 'asdfdsaf', NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (49, '听弹琴\n(刘长卿)', 'dadsf', NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (50, '送上人\n(刘长卿)', '123', NULL, NULL, NULL, '2024-01-21', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (51, '玉台体\n(权德舆)', '213', '2024/01/26/36b4c5f26e1e46119060900840f3a02c.png', NULL, 'adsfasdfadsf sadf ', '2024-01-21', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (52, '行宫\n(元稹)', NULL, NULL, NULL, '漠漠秋云起，稍稍夜寒生。\n但觉衣裳湿，无点亦无声。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (53, '1', NULL, NULL, NULL, '2', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (54, '1', NULL, NULL, NULL, '2', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (55, '1', NULL, NULL, NULL, '2', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (56, '1', NULL, NULL, NULL, '2', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (57, '行宫\n(元稹)', NULL, NULL, NULL, '漠漠秋云起，稍稍夜寒生。\n但觉衣裳湿，无点亦无声。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (148, '送上人', '(刘长卿)', '2024/01/31/446ed3e086094fada20408866d31dea1.jpg', NULL, '<p>孤云将野鹤，岂向人间住。 莫买沃洲山，时人已知处。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (147, '听弹琴', '(刘长卿)', '2024/01/31/b9ee67e0102c41098a1acb08be0a0d2d.jpg', NULL, '<p>泠泠七弦上，静听松风寒。(七弦 一作：七丝) 古调虽自爱，今人多不弹。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (146, '送灵澈上人', '(刘长卿)', '2024/01/31/72f6d3497dda4b7b88e784e167d631f7.jpg', NULL, '<p>苍苍竹林寺，杳杳钟声晚。 荷笠带斜阳，青山独归远。(斜阳 一作：夕阳)</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (145, '送崔九', '(裴迪)', '2024/01/31/c8a6693713094002add04d63f337cefc.jpg', NULL, '<p>归山深浅去，须尽丘壑美。 莫学武陵人，暂游桃源里。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (143, '宫词', '(张祜)', '2024/01/31/7863de1613d8453faf3334b7a94d186a.jpg', NULL, '<p>故国三千里，深宫二十年。 一声何满子，双泪落君前。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (144, '寻隐者不遇', '(贾岛)', '2024/01/31/275fe33864a3480abe59a3eb7844ac75.jpg', NULL, '<p>松下问童子，言师采药去。 只在此山中，云深不知处。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (142, '终南望余雪', '(祖咏)', '2024/01/31/266d53f95ab8469abb1e12d6e259ce5e.jpg', NULL, '<p>终南阴岭秀，积雪浮云端。 林表明霁色，城中增暮寒。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (141, '秋夜寄邱员外', '(韦应物)', '2024/01/31/c2041f1997794406af427f9fca3b31ea.jpg', NULL, '<p>怀君属秋夜，散步咏凉天。 空山松子落，幽人应未眠。(空山 一作：山空)</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (140, '江雪', '(柳宗元)', '2024/01/31/c08507ef8eba43f9ad48be238e37b369.jpg', NULL, '<p>千山鸟飞绝，万径人踪灭。 孤舟蓑笠翁，独钓寒江雪。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (139, '春怨', '(金昌绪)', '2024/01/31/7b240c4c36da44b797a55bce4c773e2f.jpg', NULL, '<p>打起黄莺儿，莫教枝上啼。 啼时惊妾梦，不得到辽西。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (138, '春晓', '(孟浩然)', '2024/01/31/70d97624e7524b08a168469657c78f4c.jpg', NULL, '<p>春眠不觉晓，处处闻啼鸟。 夜来风雨声，花落知多少。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (137, '宿建德江', '(孟浩然)', '2024/01/31/6804e2b8248447ebba5f81a23ac0dba1.jpg', NULL, '<p>移舟泊烟渚，日暮客愁新。 野旷天低树，江清月近人。</p>', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (136, '八阵图', '(杜甫)', NULL, NULL, '功盖三分国，名成八阵图。（名成 一作：名高）\n江流石不转，遗恨失吞吴。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (135, '渡汉江', '(宋之问)', NULL, NULL, '岭外音书断，经冬复历春。\n近乡情更怯，不敢问来人。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (134, '听筝', '(李端)', NULL, NULL, '鸣筝金粟柱，素手玉房前。\n欲得周郎顾，时时误拂弦。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (133, '登乐游原', '(李商隐)', NULL, NULL, '向晚意不适，驱车登古原。\n夕阳无限好，只是近黄昏。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (131, '静夜思', '(李白)', NULL, NULL, '床前明月光，疑是地上霜。\n举头望明月，低头思故乡。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (132, '怨情', '(李白)', NULL, NULL, '美人卷珠帘，深坐蹙蛾眉。(蹙 一作：颦)\n但见泪痕湿，不知心恨谁。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (130, '哥舒歌', '(西鄙人)', NULL, NULL, '北斗七星高，哥舒夜带刀。\n至今窥牧马，不敢过临洮。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (128, '山中送别', '(王维)', NULL, NULL, '山中相送罢，日暮掩柴扉。\n春草明年绿，王孙归不归？(明年 一作：年年)', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (129, '问刘十九', '(白居易)', NULL, NULL, '绿蚁新醅酒，红泥小火炉。\n晚来天欲雪，能饮一杯无？', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (127, '竹里馆', '(王维)', NULL, NULL, '独坐幽篁里，弹琴复长啸。\n深林人不知，明月来相照。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (126, '鹿柴', '(王维)', NULL, NULL, '空山不见人，但闻人语响。\n返景入深林，复照青苔上。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (124, '相思', '(王维)', NULL, NULL, '红豆生南国，春来发几枝。\n愿君多采撷，此物最相思。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (125, '杂诗', '(王维)', NULL, NULL, '君自故乡来，应知故乡事。\n来日绮窗前，寒梅著花未？', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (123, '新嫁娘词', '(王建)', NULL, NULL, '三日入厨下，洗手作羹汤。\n未谙姑食性，先遣小姑尝。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (122, '登鹳雀楼', '(王之涣)', NULL, NULL, '白日依山尽，黄河入海流。\n欲穷千里目，更上一层楼。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (121, '行宫', '(元稹)', NULL, NULL, '寥落古行宫，宫花寂寞红。\n白头宫女在，闲坐说玄宗。', '2024-01-30', 0, 0, NULL, NULL, NULL, NULL);
INSERT INTO `news` (`id`, `title`, `fTitle`, `pic`, `s_pic`, `contents`, `update`, `num`, `top`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (149, '玉台体', '(权德舆)', '2024/01/31/5f5e36a1bdf14a1ab026a3abb8d8d366.jpg', NULL, '昨夜裙带解，今朝蟢子飞。\n铅华不可弃，莫是藁砧归。', '2024-01-30', 0, 0, '1', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT '0',
  `name` varchar(100) DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `pic` varchar(255) DEFAULT NULL,
  `contents` text,
  `num` int(11) NOT NULL DEFAULT '0',
  `top` int(11) NOT NULL DEFAULT '0',
  `update` date DEFAULT NULL,
  `author` varchar(30) DEFAULT NULL,
  `webtitle` varchar(80) DEFAULT NULL COMMENT '网页标题',
  `webkey` varchar(160) DEFAULT NULL COMMENT '网页关键词',
  `webdes` varchar(200) DEFAULT NULL COMMENT '网页描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=112 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (1, 1, '芙蓉楼送辛渐', NULL, '2024/01/30/b14e277ba89e4515b716b8d1adc9a59a.png', '<p><img src=\"2024/01/30/04825f7716a84e49a49b560e16af5a4d.png\"></p><p><br></p><p>adfs</p><p>sdaf</p><p>asdfasdfasdfasdf</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><img src=\"2024/01/30/c43abb5c0db14278b691b0a30cc48ab8.png\"><img src=\"2024/01/30/04825f7716a84e49a49b560e16af5a4d.png\"></p><p><br></p><p>adfs</p><p>sdaf</p><p>asdfasdfasdfasdf</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><img src=\"2024/01/30/c43abb5c0db14278b691b0a30cc48ab8.png\"><img src=\"2024/01/30/04825f7716a84e49a49b560e16af5a4d.png\"></p><p><br></p><p>adfs</p><p>sdaf</p><p>asdfasdfasdfasdf</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><img src=\"2024/01/30/c43abb5c0db14278b691b0a30cc48ab8.png\"><img src=\"2024/01/30/04825f7716a84e49a49b560e16af5a4d.png\"></p><p><br></p><p>adfs</p><p>sdaf</p><p>asdfasdfasdfasdf</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><img src=\"2024/01/30/c43abb5c0db14278b691b0a30cc48ab8.png\"><img src=\"2024/01/30/04825f7716a84e49a49b560e16af5a4d.png\"></p><p><br></p><p>adfs</p><p>sdaf</p><p>asdfasdfasdfasdf</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><img src=\"2024/01/30/c43abb5c0db14278b691b0a30cc48ab8.png\"><img src=\"2024/01/30/04825f7716a84e49a49b560e16af5a4d.png\"></p><p><br></p><p>adfs</p><p>sdaf</p><p>asdfasdfasdfasdf</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><img src=\"2024/01/30/c43abb5c0db14278b691b0a30cc48ab8.png\"></p>', 184, 9, NULL, '1', NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (2, 20, '寄令狐郎中', NULL, '2024/01/30/e9e846edda774ab49114facc6cad6fde.jpeg', '<p>阿达是的<img src=\"2024/01/29/a7c4f888b4a345dc912330cabd191826.png\">阿</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p>石创德赛</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p>电池<img src=\"2024/01/29/90c4972de86d40d3b3e32c6a3af11f85.png\">打撒发斯</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p>蒂芬</p><p><br></p><p><br></p><p><img src=\"2024/01/29/7b9cd40830784550b0e97e3bd8adb133.png\"></p>', 61, 9, '2024-01-31', '1', NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (3, 22, '芙蓉楼送辛渐', NULL, '2024/01/30/d3494671778546d69268564bbda5ab37.jpeg', '<p>sadfadsf</p>', 4, 9, NULL, '1', NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (4, 23, '后宫词', NULL, '2024/01/30/d7c7d35985f34b6c805a011dda51f308.jpeg', '<p>sadfadsf</p>', 6, 9, NULL, '1', NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (5, 25, '近试上张水部', NULL, '2024/01/30/bb49f8d55e47482ab30261c5e2cb8664.jpeg', '<p>sadfadsf</p>', 9, 9, NULL, '1', NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (8, 26, '吃的撒擦打车a\'d\'s\'c', NULL, '2024/01/30/f47b6f1b682e44968fee7bb510d4c0e8.jpeg', '<p>擦打车打车沙丁胺醇</p>', 8, 9, NULL, '1', NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (9, 25, '早发白帝城', NULL, '2024/01/30/8995890a8a2a4d819b09bce53bab7517.png', '<p>阿斯蒂芬阿第三方阿第三方答复阿斯蒂芬、</p><p>1</p><p>2</p><p><br></p><p><img src=\"2024/01/31/35528cf686c1480994d49c939c970e6f.jpg\"></p><p>3</p><p>3</p><p><br></p><p><br></p><p><img src=\"2024/01/31/08d4850475a64cf0a7af81f917ff921b.jpg\"></p><p><br></p><p><br></p><p>4</p><p><br></p><p>45</p><p>5</p><p>阿斯蒂芬阿第三方阿第三方答复阿斯蒂芬、</p><p>1</p><p>2</p><p><br></p><p><img src=\"2024/01/31/35528cf686c1480994d49c939c970e6f.jpg\"></p><p>3</p><p>3</p><p><br></p><p><br></p><p><img src=\"2024/01/31/08d4850475a64cf0a7af81f917ff921b.jpg\"></p><p><br></p><p><br></p><p>4</p><p><br></p><p>45</p><p>5</p><p><br></p><p><br></p><p>阿斯蒂芬阿第三方阿第三方答复阿斯蒂芬、</p><p>1</p><p>2</p><p><br></p><p><img src=\"2024/01/31/35528cf686c1480994d49c939c970e6f.jpg\"></p><p>3</p><p>3</p><p><br></p><p><br></p><p><img src=\"2024/01/31/08d4850475a64cf0a7af81f917ff921b.jpg\"></p><p><br></p><p><br></p><p>4</p><p><br></p><p>45</p><p>5</p><p><br></p><p><br></p><p>阿斯蒂芬阿第三方阿第三方答复阿斯蒂芬、</p><p>1</p><p>2</p><p><br></p><p><img src=\"2024/01/31/35528cf686c1480994d49c939c970e6f.jpg\"></p><p>3</p><p>3</p><p><br></p><p><br></p><p><img src=\"2024/01/31/08d4850475a64cf0a7af81f917ff921b.jpg\"></p><p><br></p><p><br></p><p>4</p><p><br></p><p>45</p><p>5</p><p><br></p><p><br></p><p>阿斯蒂芬阿第三方阿第三方答复阿斯蒂芬、</p><p>1</p><p>2</p><p><br></p><p><img src=\"2024/01/31/35528cf686c1480994d49c939c970e6f.jpg\"></p><p>3</p><p>3</p><p><br></p><p><br></p><p><img src=\"2024/01/31/08d4850475a64cf0a7af81f917ff921b.jpg\"></p><p><br></p><p><br></p><p>4</p><p><br></p><p>45</p><p>5</p>', 136, 9, '2024-01-31', '1', NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (10, 1, '芙蓉楼送辛渐', '(王昌龄)', '2024/01/30/d7c7d35985f34b6c805a011dda51f308.jpeg', '寒雨连江夜入吴，平明送客楚山孤。\n洛阳亲友如相问，一片冰心在玉壶。', 3, 9, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (94, 23, '寄人', '(张泌)', NULL, '别梦依依到谢家，小廊回合曲阑斜。\n多情只有春庭月，犹为离人照落花。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (95, 23, '题金陵渡', '(张祜)', NULL, '金陵津渡小山楼，一宿行人自可愁。\n潮落夜江斜月里，两三星火是瓜洲。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (96, 23, '赠内人', '(张祜)', NULL, '禁门宫树月痕过，媚眼惟看宿鹭窠。\n斜拔玉钗灯影畔，剔开红焰救飞蛾。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (97, 23, '集灵台·其一', '(张祜)', NULL, '日光斜照集灵台，红树花迎晓露开。\n昨夜上皇新授箓，太真含笑入帘来。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (98, 23, '集灵台·其二', '(张祜)', NULL, '虢国夫人承主恩，平明骑马入宫门。\n却嫌脂粉污颜色，淡扫蛾眉朝至尊。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (99, 23, '枫桥夜泊', '(张继)', NULL, '月落乌啼霜满天，江枫渔火对愁眠。\n姑苏城外寒山寺，夜半钟声到客船。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (100, 23, '陇西行', '(陈陶)', NULL, '誓扫匈奴不顾身，五千貂锦丧胡尘。\n可怜无定河边骨，犹是春闺梦里人！(春闺 一作：深闺)', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (101, 23, '杂诗', '(佚名)', NULL, '近寒食雨草萋萋，著麦苗风柳映堤。\n等是有家归未得，杜鹃休向耳边啼。(等 一作：早)', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (92, 23, '滁州西涧', '(韦应物)', NULL, '独怜幽草涧边生，上有黄鹂深树鸣。\n春潮带雨晚来急，野渡无人舟自横。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (91, 23, '金陵图', '(韦庄)', NULL, '谁谓伤心画不成，画人心逐世人情。\n君看六幅南朝事，老木寒云满故城。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (90, 20, '征人怨', '(柳中庸)', NULL, '岁岁金河复玉关，朝朝马策与刀环。\n三春白雪归青冢，万里黄河绕黑山。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (89, 20, '泊秦淮', '(杜牧)', NULL, '烟笼寒水月笼沙，夜泊秦淮近酒家。\n商女不知亡国恨，隔江犹唱后庭花。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (88, 20, '赤壁', '(杜牧)', NULL, '折戟沉沙铁未销，自将磨洗认前朝。\n东风不与周郎便，铜雀春深锁二乔。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (87, 20, '将赴吴兴登乐游原一绝', '(杜牧)', NULL, '清时有味是无能，闲爱孤云静爱僧。\n欲把一麾江海去，乐游原上望昭陵。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (86, 20, '秋夕', '(杜牧)', NULL, '银烛秋光冷画屏，轻罗小扇扑流萤。\n天阶夜色凉如水，卧看牵牛织女星。(天阶 一作：天街；卧看 一作：坐看)', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (85, 20, '遣怀', '(杜牧)', NULL, '落魄江湖载酒行，楚腰纤细掌中轻。(江湖 一作：江南；纤细 一作：肠断)\n十年一觉扬州梦，赢得青楼薄幸名。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (84, 20, '寄扬州韩绰判官', '(杜牧)', NULL, '青山隐隐水迢迢，秋尽江南草未凋。\n二十四桥明月夜，玉人何处教吹箫？', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (83, 20, '金谷园', '(杜牧)', NULL, '繁华事散逐香尘，流水无情草自春。\n日暮东风怨啼鸟，落花犹似坠楼人。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (82, 20, '赠别·其二', '(杜牧)', NULL, '多情却似总无情，唯觉尊前笑不成。(尊 一作：樽)\n蜡烛有心还惜别，替人垂泪到天明。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (81, 20, '赠别·其一', '(杜牧)', NULL, '娉娉袅袅十三余，豆蔻梢头二月初。\n春风十里扬州路，卷上珠帘总不如。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (80, 20, '江南逢李龟年', '(杜甫)', NULL, '岐王宅里寻常见，崔九堂前几度闻。\n正是江南好风景，落花时节又逢君。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (79, 20, '为有', '(李商隐)', NULL, '为有云屏无限娇，凤城寒尽怕春宵。\n无端嫁得金龟婿，辜负香衾事早朝。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (78, 20, '寄令狐郎中', '(李商隐)', NULL, '嵩云秦树久离居，双鲤迢迢一纸书。\n休问梁园旧宾客，茂陵秋雨病相如。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (77, 20, '夜雨寄北', '(李商隐)', NULL, '君问归期未有期，巴山夜雨涨秋池。\n何当共剪西窗烛，却话巴山夜雨时。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (76, 20, '嫦娥', '(李商隐)', NULL, '云母屏风烛影深，长河渐落晓星沉。\n嫦娥应悔偷灵药，碧海青天夜夜心。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (75, 20, '瑶池', '(李商隐)', NULL, '瑶池阿母绮窗开，黄竹歌声动地哀。\n八骏日行三万里，穆王何事不重来。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (74, 20, '隋宫', '(李商隐)', NULL, '乘兴南游不戒严，九重谁省谏书函。\n春风举国裁宫锦，半作障泥半作帆。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (73, 20, '贾生', '(李商隐)', NULL, '宣室求贤访逐臣，贾生才调更无伦。\n可怜夜半虚前席，不问苍生问鬼神。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (72, 20, '夜上受降城闻笛', '(李益)', NULL, '回乐烽前沙似雪，受降城外月如霜。(回乐烽 一作：回乐峰)\n不知何处吹芦管，一夜征人尽望乡。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (71, 20, '早发白帝城', '(李白)', NULL, '朝辞白帝彩云间，千里江陵一日还。\n两岸猿声啼不住，轻舟已过万重山。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (70, 20, '黄鹤楼送孟浩然之广陵', '(李白)', NULL, '故人西辞黄鹤楼，烟花三月下扬州。\n孤帆远影碧空尽，唯见长江天际流。 (唯 通：惟)', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (69, 20, '逢入京使', '(岑参)', NULL, '故园东望路漫漫，双袖龙钟泪不干。\n马上相逢无纸笔，凭君传语报平安。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (68, 20, '近试上张水部', '(朱庆馀)', NULL, '洞房昨夜停红烛，待晓堂前拜舅姑。\n妆罢低声问夫婿，画眉深浅入时无。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (67, 20, '宫中词', '(朱庆馀)', NULL, '寂寂花时闭院门，美人相并立琼轩。\n含情欲说宫中事，鹦鹉前头不敢言。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (93, 23, '桃花溪', '(张旭)', NULL, '隐隐飞桥隔野烟，石矶西畔问渔船。\n桃花尽日随流水，洞在清溪何处边。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (65, 20, '凉州词', '(王翰)', NULL, '葡萄美酒夜光杯，欲饮琵琶马上催。\n醉卧沙场君莫笑，古来征战几人回？', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (64, 20, '九月九日忆山东兄弟', '(王维)', NULL, '独在异乡为异客，每逢佳节倍思亲。\n遥知兄弟登高处，遍插茱萸少一人。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (63, 20, '春宫曲', '(王昌龄)', NULL, '昨夜风开露井桃，未央前殿月轮高。\n平阳歌舞新承宠，帘外春寒赐锦袍。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (66, 20, '后宫词', '(白居易)', NULL, '泪湿罗巾梦不成，夜深前殿按歌声。(湿 一作：尽)\n红颜未老恩先断，斜倚薰笼坐到明。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (62, 1, '闺怨', '(王昌龄)', NULL, '闺中少妇不知愁，春日凝妆上翠楼。(不知 一作：不曾)\n忽见陌头杨柳色，悔教夫婿觅封侯。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (61, 1, '芙蓉楼送辛渐', '(王昌龄)', NULL, '寒雨连江夜入吴，平明送客楚山孤。\n洛阳亲友如相问，一片冰心在玉壶。', 4, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (102, 23, '回乡偶书·其一', '(贺知章)', NULL, '少小离家老大回，乡音无改鬓毛衰。\n儿童相见不相识，笑问客从何处来。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (103, 23, '瑶瑟怨', '(温庭筠)', NULL, '冰簟银床梦不成，碧天如水夜云轻。\n雁声远过潇湘去，十二楼中月自明。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (104, 23, '月夜', '(刘方平)', NULL, '更深月色半人家，北斗阑干南斗斜。\n今夜偏知春气暖，虫声新透绿窗纱。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (105, 23, '春怨', '(刘方平)', NULL, '纱窗日落渐黄昏，金屋无人见泪痕。\n寂寞空庭春欲晚，梨花满地不开门。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (106, 23, '乌衣巷', '(刘禹锡)', NULL, '朱雀桥边野草花，乌衣巷口夕阳斜。\n旧时王谢堂前燕，飞入寻常百姓家。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (107, 23, '春词', '(刘禹锡)', NULL, '新妆宜面下朱楼，深锁春光一院愁。\n行到中庭数花朵，蜻蜓飞上玉搔头。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (108, 23, '马嵬坡', '(郑畋)', NULL, '玄宗回马杨妃死，云雨难忘日月新。(难忘 一作：虽忘)\n终是圣明天子事，景阳宫井又何人。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (109, 23, '寒食', '(韩翃)', NULL, '春城无处不飞花，寒食东风御柳斜。\n日暮汉宫传蜡烛，轻烟散入五侯家。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (110, 23, '已凉', '(韩偓)', NULL, '碧阑干外绣帘垂，猩色屏风画折枝。(猩色 一作：猩血)\n八尺龙须方锦褥，已凉天气未寒时。', 1, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product` (`id`, `pid`, `name`, `title`, `pic`, `contents`, `num`, `top`, `update`, `author`, `webtitle`, `webkey`, `webdes`) VALUES (111, 23, '宫词', '(顾况)', NULL, '长乐宫连上苑春，玉楼金殿艳歌新。\n君门一入无由出，唯有宫莺得见人。', 1, 1, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for productclass
-- ----------------------------
DROP TABLE IF EXISTS `productclass`;
CREATE TABLE `productclass` (
  `classid` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号|0|0|0',
  `classname` varchar(50) NOT NULL COMMENT '分类名称|1|0|1',
  `classpower` varchar(100) NOT NULL COMMENT '分类编码|0|0|0',
  `depth` int(11) NOT NULL COMMENT '分类深度|0|0|0',
  `rootid` int(11) NOT NULL COMMENT '分类根ID|0|0|0',
  `classcontents` varchar(500) DEFAULT NULL,
  `classpic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`classid`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='产品分类';

-- ----------------------------
-- Records of productclass
-- ----------------------------
BEGIN;
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (1, '第一个分类', '0014', 4, 0, '分类内容', '2024/01/30/f61cae0d971042e195f5f1372a426790.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (2, '第一个人类小分类', '001400010001', 12, 20, 'aaasdfadsfadsf', '2024/01/30/ff597fbc7ace4426abcc9c14739ab07d.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (22, '111', '00140001000100010001', 20, 21, '', '2024/01/30/48d937dc1e5c4782a0b3ad8d4a0c6f28.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (23, '1111', '001400010001000100010001', 24, 22, '111', '2024/01/30/d791c367963545edbdb91d17ddfe6296.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (20, '1@@@', '00140001', 8, 24, 'asdasd', '2024/01/30/4f030e280191467f86d9227b34e54ae1.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (21, '11asdfsadf', '0014000100010001', 16, 2, '', '2024/01/30/9e21c72f75f840afb1b5f7dd3f4c8583.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (24, '美妆', '0014', 4, 0, '1231312', '2024/01/30/2f720c2b0fd649949730b5dbe260be71.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (25, '超市百货', '0011', 4, 0, '', '2024/01/30/9982df6df3114620aafb4f3a1f7d92c9.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (26, '五金工具', '0012', 4, 0, '', '2024/01/30/8bd23f1d85a94d5a82dd882fe9c547e1.png');
INSERT INTO `productclass` (`classid`, `classname`, `classpower`, `depth`, `rootid`, `classcontents`, `classpic`) VALUES (27, '优惠卷', '0013', 4, 0, '', '2024/01/30/4c979a3e4a9d439ea1a1066aaea179c4.png');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleName` varchar(255) DEFAULT NULL COMMENT '角色名称',
  `roleDesc` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `roleMenus` text COMMENT '角色权限',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (1, '系统管理员', '管理员应该拥有所有权限', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (2, '内容管理员', '管理日常工作', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (3, '1', '1', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (4, '2', '2', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (5, '3', '3', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (6, '4', '4', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (7, '5', '5', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (8, '6', '6', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (9, '7', '7', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (10, '8', '8', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (11, '9', '9', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (12, '11', '11', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (13, '12', '12', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (16, '222', '444', '');
INSERT INTO `role` (`id`, `roleName`, `roleDesc`, `roleMenus`) VALUES (17, 'fffff', 'fffff', '');
COMMIT;

-- ----------------------------
-- Table structure for rolebuttons
-- ----------------------------
DROP TABLE IF EXISTS `rolebuttons`;
CREATE TABLE `rolebuttons` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `roleMenuId` bigint(20) DEFAULT NULL COMMENT '关联ID，角色属于菜单ID',
  `buttonName` varchar(255) DEFAULT NULL COMMENT '按钮中文名称',
  `buttonType` varchar(255) DEFAULT NULL COMMENT '按钮英文类型便于匹配是否有权限',
  `roleId` int(11) DEFAULT NULL,
  `menuId` int(11) NOT NULL COMMENT '菜单真实ID',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5427312901128187 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rolebuttons
-- ----------------------------
BEGIN;
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650138025, 2, '批量删除', 'batchDeletion', 1, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650142525, 2, '删除', 'delete', 1, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650142484, 2, '编辑', 'edit', 1, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650141626, 2, '导出', 'export', 1, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650146561, 2, '导入', 'import', 1, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650145999, 2, '添加', 'add', 1, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650149389, 4, '删除', 'delete', 1, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650150654, 4, '编辑', 'edit', 1, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650153299, 4, '添加', 'add', 1, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650152255, 5, '删除', 'delete', 1, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650152826, 5, '编辑', 'edit', 1, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650159803, 5, '添加', 'add', 1, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650159735, 7, '删除', 'delete', 1, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650156657, 7, '编辑', 'edit', 1, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650156747, 7, '新增', 'add', 1, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650156625, 8, '编辑', 'edit', 1, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650159633, 8, '删除', 'delete', 1, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650157682, 8, '批量删除', 'batchDelete', 1, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650157345, 8, '新增', 'add', 1, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650162801, 9, '批量同步', 'batchSync', 1, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650162647, 9, '批量删除', 'batchDelete', 1, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163716, 9, '新增按钮', 'addButton', 1, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650162308, 9, '新增菜单', 'addMenu', 1, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163124, 9, '删除', 'delete', 1, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650162512, 9, '编辑', 'edit', 1, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163718, 13, '批量删除', 'batchDeletion', 2, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163719, 13, '删除', 'delete', 2, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163720, 13, '编辑', 'edit', 2, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163721, 13, '导出', 'export', 2, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163722, 13, '导入', 'import', 2, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163723, 13, '添加', 'add', 2, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163724, 15, '删除', 'delete', 2, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163725, 15, '编辑', 'edit', 2, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163726, 15, '添加', 'add', 2, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163727, 16, '删除', 'delete', 2, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163728, 16, '编辑', 'edit', 2, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5333436650163729, 16, '添加', 'add', 2, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004169373, 31, '添加', 'add', 16, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004167307, 31, '导入', 'import', 16, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004162486, 31, '导出', 'export', 16, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004163073, 31, '编辑', 'edit', 16, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004164445, 31, '删除', 'delete', 16, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004160640, 31, '批量删除', 'batchDeletion', 16, 6);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004161524, 29, '编辑', 'edit', 16, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004155770, 29, '删除', 'delete', 16, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004155188, 29, '新增菜单', 'addMenu', 16, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004156565, 29, '新增按钮', 'addButton', 16, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004156044, 29, '批量删除', 'batchDelete', 16, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004151576, 29, '批量同步', 'batchSync', 16, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004152156, 28, '新增', 'add', 16, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004146140, 28, '批量删除', 'batchDelete', 16, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004146399, 28, '删除', 'delete', 16, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004146184, 28, '编辑', 'edit', 16, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004143790, 27, '新增', 'add', 16, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004144452, 27, '编辑', 'edit', 16, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004135248, 27, '删除', 'delete', 16, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004167488, 33, '删除', 'delete', 16, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004172827, 33, '编辑', 'edit', 16, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004172145, 33, '添加', 'add', 16, 9);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004172572, 34, '删除', 'delete', 16, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004175989, 34, '编辑', 'edit', 16, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427288004176728, 34, '添加', 'add', 16, 8);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901102124, 36, '删除', 'delete', 17, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901104398, 36, '编辑', 'edit', 17, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901104180, 36, '新增', 'add', 17, 2);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901106828, 37, '编辑', 'edit', 17, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901108193, 37, '删除', 'delete', 17, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901110363, 37, '批量删除', 'batchDelete', 17, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901111166, 37, '新增', 'add', 17, 3);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901113757, 38, '批量同步', 'batchSync', 17, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901115052, 38, '批量删除', 'batchDelete', 17, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901112516, 38, '新增按钮', 'addButton', 17, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901114204, 38, '新增菜单', 'addMenu', 17, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901114668, 38, '删除', 'delete', 17, 4);
INSERT INTO `rolebuttons` (`id`, `roleMenuId`, `buttonName`, `buttonType`, `roleId`, `menuId`) VALUES (5427312901112593, 38, '编辑', 'edit', 17, 4);
COMMIT;

-- ----------------------------
-- Table structure for rolemenus
-- ----------------------------
DROP TABLE IF EXISTS `rolemenus`;
CREATE TABLE `rolemenus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleId` int(11) DEFAULT '0' COMMENT '角色ID',
  `menuId` int(11) DEFAULT NULL COMMENT '菜单ID',
  `menuTitle` varchar(255) DEFAULT NULL COMMENT '菜单名称',
  `menuButton` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rolemenus
-- ----------------------------
BEGIN;
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (1, 1, 5, '新闻', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (2, 1, 6, '新闻组件', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (3, 1, 7, '产品', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (4, 1, 8, '产品管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (5, 1, 9, '产品分类', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (6, 1, 1, '系统管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (7, 1, 2, '角色管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (8, 1, 3, '用户管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (9, 1, 4, '菜单管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (13, 2, 6, '新闻组件', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (12, 2, 5, '新闻', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (14, 2, 7, '产品', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (15, 2, 8, '产品管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (16, 2, 9, '产品分类', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (32, 16, 7, '产品', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (31, 16, 6, '新闻组件', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (30, 16, 5, '新闻', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (29, 16, 4, '菜单管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (28, 16, 3, '用户管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (27, 16, 2, '角色管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (26, 16, 1, '系统管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (33, 16, 9, '产品管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (34, 16, 8, '产品分类', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (35, 17, 1, '系统管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (36, 17, 2, '角色管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (37, 17, 3, '用户管理', '');
INSERT INTO `rolemenus` (`id`, `roleId`, `menuId`, `menuTitle`, `menuButton`) VALUES (38, 17, 4, '菜单管理', '');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码，加密存储',
  `birthday` date DEFAULT NULL,
  `roleId` int(11) DEFAULT '0',
  `createTime` date DEFAULT NULL,
  `updateTime` date DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` (`id`, `username`, `password`, `birthday`, `roleId`, `createTime`, `updateTime`, `avatar`) VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '2023-04-22', 1, NULL, '2023-10-16', '/public/avatar/202310/46bb0505-8a03-48f1-89d7-e24406502a18.jpg');
INSERT INTO `t_user` (`id`, `username`, `password`, `birthday`, `roleId`, `createTime`, `updateTime`, `avatar`) VALUES (2, 'user1', '24c9e15e52afc47c225b757e7bee1f9d', '2023-09-07', 2, '2023-09-08', '2023-09-08', NULL);
INSERT INTO `t_user` (`id`, `username`, `password`, `birthday`, `roleId`, `createTime`, `updateTime`, `avatar`) VALUES (3, '33333', '1a100d2c0dab19c4430e7d73762b3423', '2024-01-14', 4, '2024-01-14', '2024-01-14', NULL);
INSERT INTO `t_user` (`id`, `username`, `password`, `birthday`, `roleId`, `createTime`, `updateTime`, `avatar`) VALUES (4, 'dsfgdsfg', '2f6b9ccadcf54ce802ec4f9004dbc739', '2024-01-08', 10, '2024-01-14', '2024-01-14', NULL);
INSERT INTO `t_user` (`id`, `username`, `password`, `birthday`, `roleId`, `createTime`, `updateTime`, `avatar`) VALUES (7, 'bbbdfd\'fv', 'ec542da8082faef897737558d8dcb372', '2024-01-02', 12, '2024-01-14', '2024-01-14', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
